package com.it.dao;

import com.it.domain.SongList;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SongListMapper {

    int DeleteSongList(Integer id);

    int UpdateSongList(SongList songlist);//修改


    @Select("select count(id) from song_list")
    Integer SelectTotal();

    int AddSongList(SongList songlist);


    List<SongList> SelectAll(@Param("PageNum") Integer PageNum, @Param("PageSize") Integer PageSize, @Param("title") String title);//查询所有

    SongList SelectById(Integer id);

    List<SongList> GetAll();

    SongList SelectByTitle(String title,Integer listUserid);

    SongList SelectSongList(String title,Integer userId);

    List<SongList> SelectMainSongList(@Param("ids") Integer[] ids);

    List<SongList> getSongListSong(Integer SongListId);
}
